﻿CREATE TABLE [dbo].[FC_Product] (
    [IdProduct]   INT           IDENTITY (1, 1) NOT NULL,
    [CodProduct]  VARCHAR (50)  NOT NULL,
    [IdSegmentPL] INT           NULL,
    [DesProduct]  VARCHAR (150) NULL,
    [IdEntityF]   INT           NULL,
    [IdUOM]       INT           NULL,
    [DateIng]     DATETIME      NULL,
    [DateMod]     DATETIME      NULL,
    CONSTRAINT [PK_FC_Product_1] PRIMARY KEY CLUSTERED ([IdProduct] ASC),
    CONSTRAINT [FK_FC_Product_FC_Entity] FOREIGN KEY ([IdEntityF]) REFERENCES [dbo].[FC_Entity] ([IdEntityF]),
    CONSTRAINT [FK_FC_Product_FC_Segment] FOREIGN KEY ([IdSegmentPL]) REFERENCES [dbo].[FC_SegmentPL] ([IdSegmentPL]),
    CONSTRAINT [FK_FC_Product_FC_UOM] FOREIGN KEY ([IdUOM]) REFERENCES [dbo].[FC_UOM] ([IdUOM])
);

